﻿<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <Author>ch</Author>
  <LastAuthor>dingyangfan</LastAuthor>
  <LastPrinted>2010-07-25T08:10:45Z</LastPrinted>
  <Created>2010-07-22T00:32:23Z</Created>
  <LastSaved>2011-06-19T08:27:12Z</LastSaved>
  <Company>kl</Company>
  <Version>12.00</Version>
 </DocumentProperties>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>11760</WindowHeight>
  <WindowWidth>20730</WindowWidth>
  <WindowTopX>240</WindowTopX>
  <WindowTopY>75</WindowTopY>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Center"/>
   <Borders/>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="12"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
  <Style ss:ID="m79080960">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders/>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="20" ss:Bold="1"/>
   <Interior/>
   <NumberFormat ss:Format="@"/>
  </Style>
  <Style ss:ID="m79080980">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="16"/>
   <Interior/>
   <NumberFormat ss:Format="@"/>
  </Style>
  <Style ss:ID="s62">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134"/>
  </Style>
  <Style ss:ID="s63">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134"/>
  </Style>
  <Style ss:ID="s64">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134"/>
   <NumberFormat ss:Format="yyyy/m/d;@"/>
  </Style>
  <Style ss:ID="s65">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134"/>
  </Style>
  <Style ss:ID="s66">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134"/>
   <NumberFormat ss:Format="@"/>
  </Style>
  <Style ss:ID="s67">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134"/>
  </Style>
  <Style ss:ID="s68">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="12" ss:Bold="1"/>
   <Interior/>
  </Style>
  <Style ss:ID="s69">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="12" ss:Bold="1"/>
   <Interior/>
   <NumberFormat ss:Format="yyyy/m/d;@"/>
  </Style>
  <Style ss:ID="s70">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="12" ss:Bold="1"/>
   <Interior/>
   <NumberFormat ss:Format="@"/>
  </Style>
 </Styles>
 <Worksheet ss:Name="预约汇总">
  <Table ss:ExpandedColumnCount="24" ss:ExpandedRowCount="5" x:FullColumns="1"
   x:FullRows="1" ss:StyleID="s63" ss:DefaultColumnWidth="54"
   ss:DefaultRowHeight="26.0625">
   <Column ss:StyleID="s64" ss:AutoFitWidth="0" ss:Width="59.25"/>
   <Column ss:StyleID="s65" ss:Hidden="1" ss:AutoFitWidth="0" ss:Width="99"/>
   <Column ss:StyleID="s65" ss:Hidden="1" ss:AutoFitWidth="0"/>
   <Column ss:StyleID="s66" ss:Hidden="1" ss:AutoFitWidth="0" ss:Width="183.75"
    ss:Span="1"/>
   <Column ss:Index="6" ss:StyleID="s65" ss:Hidden="1" ss:AutoFitWidth="0"
    ss:Width="145.5"/>
   <Column ss:StyleID="s67" ss:AutoFitWidth="0" ss:Width="45.75"/>
   <Column ss:StyleID="s65" ss:Hidden="1" ss:AutoFitWidth="0"/>
   <Column ss:StyleID="s67" ss:Hidden="1" ss:AutoFitWidth="0" ss:Width="84"/>
   <Column ss:StyleID="s67" ss:AutoFitWidth="0" ss:Width="45.75"/>
   <Column ss:StyleID="s65" ss:AutoFitWidth="0" ss:Width="51"/>
   <Column ss:StyleID="s67" ss:AutoFitWidth="0" ss:Width="45.75"/>
   <Column ss:StyleID="s67" ss:Hidden="1" ss:AutoFitWidth="0"/>
   <Column ss:StyleID="s65" ss:Hidden="1" ss:AutoFitWidth="0" ss:Width="75"/>
   <Column ss:StyleID="s67" ss:Hidden="1" ss:AutoFitWidth="0" ss:Width="33.75"
    ss:Span="1"/>
   <Column ss:Index="17" ss:StyleID="s67" ss:AutoFitWidth="0" ss:Width="45.75"/>
   <Column ss:StyleID="s64" ss:Hidden="1" ss:AutoFitWidth="0" ss:Width="69.75"
    ss:Span="1"/>
   <Column ss:Index="20" ss:StyleID="s65" ss:AutoFitWidth="0" ss:Width="72"/>
   <Column ss:StyleID="s64" ss:Hidden="1" ss:AutoFitWidth="0" ss:Width="69.75"/>
   <Column ss:StyleID="s65" ss:Hidden="1" ss:AutoFitWidth="0" ss:Width="131.25"/>
   <Column ss:StyleID="s63" ss:AutoFitWidth="0" ss:Width="171.75"/>
   <Row ss:AutoFitHeight="0" ss:Height="38.25">
    <Cell ss:MergeAcross="22" ss:StyleID="m79080960"><Data ss:Type="String">网络预约日报表（2010-07-25）</Data></Cell>
    <Cell ss:StyleID="s62"/>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Height="37.5">
    <Cell ss:MergeAcross="22" ss:StyleID="m79080980"><Data ss:Type="String">制表：张三　　　　收表：李四</Data></Cell>
    <Cell ss:StyleID="s62"/>
   </Row>
   <Row ss:AutoFitHeight="0">
    <Cell ss:StyleID="s69"><Data ss:Type="String">咨询时间</Data></Cell>
    <Cell ss:StyleID="s68"><Data ss:Type="String">IP地址</Data></Cell>
    <Cell ss:StyleID="s68"><Data ss:Type="String">地区</Data></Cell>
    <Cell ss:StyleID="s70"><Data ss:Type="String">进入页</Data></Cell>
    <Cell ss:StyleID="s70"><Data ss:Type="String">咨询页</Data></Cell>
    <Cell ss:StyleID="s68"><Data ss:Type="String">搜索引擎/关键字</Data></Cell>
    <Cell ss:StyleID="s68"><Data ss:Type="String">病种</Data></Cell>
    <Cell ss:StyleID="s68"><Data ss:Type="String">咨询渠道</Data></Cell>
    <Cell ss:StyleID="s68"><Data ss:Type="String">QQ号（选填）</Data></Cell>
    <Cell ss:StyleID="s68"><Data ss:Type="String">咨询员</Data></Cell>
    <Cell ss:StyleID="s68"><Data ss:Type="String">预约号</Data></Cell>
    <Cell ss:StyleID="s68"><Data ss:Type="String">姓名</Data></Cell>
    <Cell ss:StyleID="s68"><Data ss:Type="String">代约人</Data></Cell>
    <Cell ss:StyleID="s68"><Data ss:Type="String">电话</Data></Cell>
    <Cell ss:StyleID="s68"><Data ss:Type="String">性别</Data></Cell>
    <Cell ss:StyleID="s68"><Data ss:Type="String">年龄</Data></Cell>
    <Cell ss:StyleID="s68"><Data ss:Type="String">专家</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">时间（起）</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">时间（止）</Data></Cell>
    <Cell ss:StyleID="s68"><Data ss:Type="String">就诊号</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">就诊时间</Data></Cell>
    <Cell ss:StyleID="s68"><Data ss:Type="String">回访情况</Data></Cell>
    <Cell ss:StyleID="s68"><Data ss:Type="String">备注</Data></Cell>
   </Row>
   <volist name="yuyue" id="y">
   <Row ss:AutoFitHeight="0">
    <Cell><Data ss:Type="DateTime">{$y.date}</Data></Cell>
    <Cell ss:Index="7"><Data ss:Type="String">{$y.binzhong}</Data></Cell>
    <Cell ss:Index="10"><Data ss:Type="Number">{$y.uid}</Data></Cell>
    <Cell><Data ss:Type="Number">{$y.yuyueid}</Data></Cell>
    <Cell><Data ss:Type="String">{$y.name}</Data></Cell>
    <Cell ss:Index="17"><Data ss:Type="Number">{$y.proficient}</Data></Cell>
    <Cell ss:Index="20"><Data ss:Type="Number">{$y.Medicalnumber}</Data></Cell>
    <Cell ss:Index="23"><Data ss:Type="String">{$y.comment}</Data></Cell>
   </Row>
  </volist>
  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <PageSetup>
    <Header x:Margin="0.39370078740157483"/>
    <Footer x:Margin="0.39370078740157483"/>
    <PageMargins x:Bottom="0.39370078740157483" x:Left="0.39370078740157483"
     x:Right="0.39370078740157483" x:Top="0.39370078740157483"/>
   </PageSetup>
   <Unsynced/>
   <Print>
    <ValidPrinterInfo/>
    <PaperSizeIndex>9</PaperSizeIndex>
    <HorizontalResolution>600</HorizontalResolution>
    <VerticalResolution>0</VerticalResolution>
   </Print>
   <Selected/>
   <Panes>
    <Pane>
     <Number>3</Number>
     <RangeSelection>R1C1:R1C23</RangeSelection>
    </Pane>
   </Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C3:R65536C3</Range>
   <Type>List</Type>
   <CellRangeList/>
   <Value>&quot;本市,省内,省外&quot;</Value>
   <InputMessage>通过下拉框选择</InputMessage>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C7:R65536C7</Range>
   <InputMessage>请按小组标准病种名填写</InputMessage>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C1:R65536C1</Range>
   <Type>Date</Type>
   <Qualifier>Greater</Qualifier>
   <Value>40360</Value>
   <InputTitle>必填</InputTitle>
   <InputMessage>咨询发生的时间</InputMessage>
   <ErrorStyle>Warn</ErrorStyle>
   <ErrorMessage>请输入正确的日期</ErrorMessage>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C2:R65536C2</Range>
   <ErrorMessage>咨询人的IP地址</ErrorMessage>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C4:R65536C4</Range>
   <InputMessage>咨询者访问网站的第一个页面</InputMessage>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C5:R65536C5</Range>
   <InputMessage>咨询者在哪个页面进入咨询</InputMessage>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C6:R65536C6</Range>
   <InputMessage>网站咨询软件显示的关键字信息</InputMessage>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C8:R65536C8</Range>
   <Type>List</Type>
   <CellRangeList/>
   <Value>&quot;QQ,网站客服,电话&quot;</Value>
   <InputTitle>必填</InputTitle>
   <InputMessage>请从下拉菜单中选择</InputMessage>
   <ErrorHide/>
   <ErrorStyle>Info</ErrorStyle>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C9:R65536C10</Range>
   <Type>Whole</Type>
   <Qualifier>Greater</Qualifier>
   <Value>1</Value>
   <InputTitle>可选</InputTitle>
   <InputMessage>如有QQ号信息请记录</InputMessage>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C11:R65536C11</Range>
   <InputMessage>发放的预约号</InputMessage>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C12:R65536C12</Range>
   <InputMessage>预约就诊者姓名</InputMessage>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C13:R65536C13</Range>
   <InputTitle>可选</InputTitle>
   <InputMessage>代约者姓名或与就诊者关系</InputMessage>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C14:R65536C14</Range>
   <InputMessage>如为代约，则记录代约人电话</InputMessage>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C15:R65536C15</Range>
   <Type>List</Type>
   <CellRangeList/>
   <Value>&quot;女,男&quot;</Value>
   <InputMessage>选择就诊者性别信息</InputMessage>
   <ErrorMessage>不存在的性别</ErrorMessage>
   <ErrorTitle>出错</ErrorTitle>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C16:R65536C16</Range>
   <Type>Whole</Type>
   <Min>1</Min>
   <Max>100</Max>
   <ErrorStyle>Warn</ErrorStyle>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C17:R65536C17</Range>
   <InputTitle>可选</InputTitle>
   <InputMessage>推荐或指定的专家</InputMessage>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C19:R65536C19</Range>
   <Type>Date</Type>
   <Qualifier>Greater</Qualifier>
   <Value>40360</Value>
   <InputMessage>预约的有效时间（结束）</InputMessage>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C18:R65536C18</Range>
   <Type>Date</Type>
   <Qualifier>Greater</Qualifier>
   <Value>40360</Value>
   <InputMessage>预约的有效时间（开始）</InputMessage>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C20:R65536C20</Range>
   <InputMessage>来院后就诊的唯一编号</InputMessage>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C21:R65536C21</Range>
   <InputMessage>首次到诊的时间</InputMessage>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C22:R65536C22</Range>
   <Type>List</Type>
   <CellRangeList/>
   <Value>&quot;联系不上,自然痊愈,自行治疗,他院治疗,拒绝回答&quot;</Value>
   <InputMessage>预约未就诊，必填项目</InputMessage>
   <ErrorHide/>
  </DataValidation>
  <DataValidation xmlns="urn:schemas-microsoft-com:office:excel">
   <Range>R4C23:R65536C23</Range>
   <InputMessage>与该记录有关的额外信息</InputMessage>
  </DataValidation>
 </Worksheet>
</Workbook>
